VECTOR | [3-0-0:3] |
---|---|
DESCRIPTION | Relational Database Management Systems (RDBMS) are the main systems for businesses to process transactions and store data. In real-world scenarios, organizations often maintain multiple relational databases to serve different business applications and meet different needs. Data warehouses integrated data from multiple RDBMS are built to facilitate planning and decision making in businesses. Online analytical processing (OLAP) is a technology that uses a data warehouse for answering aggregation queries often used in planning. While data warehouses hold important information about a business, the success of a business quite often depends on advanced planning and development of strategies based on customer behavior. This course introduces the key mechanisms in data warehousing and OLAP. It discusses the logical and physical design of data warehouses including data schema, data marts, and data cube technologies. In practical aspects, students study the use of data warehouses through a study of the OLAP technology, and know the common data warehousing software tools to solve real-world problems. |
Section | Date & Time | Room | Instructor | Quota | Enrol | Avail | Wait | Remarks |
---|---|---|---|---|---|---|---|---|
L01 (6038) | Mo 09:00AM - 11:50AM | Rm 201, E1 | WEN, Zeyi | 30 | 8 | 22 | 0 |